CREATE TABLE `cdb_ques_topic` (
  `topicid` int(10) unsigned NOT NULL auto_increment,
  `subject` varchar(255) NOT NULL default 'NoName',
  `message` text NOT NULL,
  `author` varchar(255) NOT NULL default 'Unknown',
  `authorid` int(8) NOT NULL default '0',
  `dateline` int(10) NOT NULL default '0',
  `person` int(8) NOT NULL default '100',
  `stop` tinyint(1) NOT NULL default '0',
  `credit` tinyint(1) NOT NULL default '0',
  `postmust` tinyint(1) NOT NULL default '0',
  `secret` tinyint(1) NOT NULL default '0',
  `exp` int(10) NOT NULL default '0',
  KEY `topicid` (`topicid`)
) ENGINE=MyISAM;

CREATE TABLE `cdb_ques_option` (
  `oid` int(10) unsigned NOT NULL auto_increment,
  `topicid` int(10) NOT NULL default '0',
  `title` varchar(255) NOT NULL default 'NoName',
  `desp` text NOT NULL,
  `mark` text NOT NULL,
  `option` text NOT NULL,
  `key` text NOT NULL,
  `order` int(8) NOT NULL default '0',
  `least` tinyint(1) NOT NULL default '0',
  `type` int(3) NOT NULL default '0',
  KEY `oid` (`oid`)
) ENGINE=MyISAM;

CREATE TABLE `cdb_ques_user` (
  `qid` int(10) unsigned NOT NULL auto_increment,
  `topicid` int(10) NOT NULL default '0',
  `author` varchar(255) NOT NULL default 'Unknown',
  `authorid` int(8) NOT NULL default '0',
  `mark` int(10) NOT NULL default '0',
  `dateline` int(10) NOT NULL default '0',
  KEY `qid` (`qid`)
) ENGINE=MyISAM;

CREATE TABLE `cdb_ques_result` (
  `qid` int(10) unsigned NOT NULL default '0',
  `topicid` int(10) unsigned NOT NULL default '0',
  `oid` int(10) unsigned NOT NULL default '0',
  `authorid` int(8) NOT NULL default '0',
  `answer` text NOT NULL
) ENGINE=MyISAM;